
***MANUSCRIPT FIGURE 1***

use "C:\Users\matt_zarit\Dropbox\Executive Particularism (Matt Zarit)\Contract Duration\May 2020\Graphics Files\Graphics June 2021\sellingout.MEgraphics.6.4.2021.dta"


twoway bar proportion category, yaxis(2) ytitle("Proportion of Each Contract Type", axis(2))  || bar value category, yaxis(1) ytitle("Total Constant Dollar Value", axis(1)) title("FIGURE 1: The Distribution and Value of Federal Contracts by Contractual Design", size(smallmed)) xlabel(1(2)8, labsize(vsmall) valuelabel) subtitle("Number of Contracts and Monetary Value") legend(label(1 "Number of Contracts") label(2 "Monetary Value)) scheme(sj) 


*** MANUSCRIPT FIGURES 2 & 4***

use "C:\Users\matt_zarit\Dropbox\Executive Particularism (Matt Zarit)\Contract Duration\May 2020\Graphics Files\sellingout.figuredata.6012021.dta"


***Figure 2A***

twoway (scatter change alignment if model==1) (rcap ll ul alignment if model==1), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for Low U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE 2A: Low U.S. Federal Government Contracting Risk -- Ideologically Aligned Agencies", size(small)) subtitle("[Multiple Bids & Fixed Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj)

***Figure 3A***

twoway (scatter change alignment if model==2) (rcap ll ul alignment if model==2), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for Low U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE 3A: Low U.S. Federal Government Contracting Risk -- Ideologically Opposed Agencies", size(small)) subtitle("[Multiple Bids & Fixed Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj)


***Figure 4A***

twoway (scatter change alignment if model==3) (rcap ll ul alignment if model==3), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for High U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE 4A: High U.S. Federal Government Contracting Risk -- Ideologically Aligned Agencies", size(small)) subtitle("[Single Bid (Closed) & Variable Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj)



***Figure 5A***

twoway (scatter change alignment if model==4) (rcap ll ul alignment if model==4), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for High U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE 5A: High U.S. Federal Government Contracting Risk -- Ideologically Opposed Agencies", size(small)) subtitle("[Single Bid (Closed) & Variable Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj)



***SI Document, Section A2 - Omitting DOD***


***Figure A2.2A***

twoway (scatter change alignment if model==5) (rcap ll ul alignment if model==5), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for Low U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A2.2A: Low U.S. Federal Government Contracting Risk -- Ideologically Aligned Agencies", size(small)) subtitle("Omit DOD: [Multiple Bids & Fixed Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(-.2(0.2)0.7)

***Figure A2.3A***

twoway (scatter change alignment if model==6) (rcap ll ul alignment if model==6), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for Low U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A2.3A: Low U.S. Federal Government Contracting Risk -- Ideologically Opposed Agencies", size(small)) subtitle("Omit DOD: [Multiple Bids & Fixed Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(-.2(0.2)0.7)


***Figure A2.4A***

twoway (scatter change alignment if model==7) (rcap ll ul alignment if model==7), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for High U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A2.4A: High U.S. Federal Government Contracting Risk -- Ideologically Aligned Agencies", size(small)) subtitle("Omit DOD: [Single Bid (Closed) & Variable Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(0(0.05)0.15)



***Figure A2.5B***

twoway (scatter change alignment if model==8) (rcap ll ul alignment if model==8), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for High U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A2.5A: High U.S. Federal Government Contracting Risk -- Ideologically Opposed Agencies", size(small)) subtitle("Omit DOD: [Single Bid (Closed) & Variable Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(0(0.05)0.15)





***SI Document, Section A2 - Omitting Set-Asides***


***Figure A3.2A***

twoway (scatter change alignment if model==9) (rcap ll ul alignment if model==9), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for Low U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A3.2A: Low U.S. Federal Government Contracting Risk -- Ideologically Aligned Agencies", size(small)) subtitle("Omit Set-Asides: [Multiple Bids & Fixed Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(-.2(0.2)0.7)

***Figure A3.3A***

twoway (scatter change alignment if model==10) (rcap ll ul alignment if model==10), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for Low U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A3.3A: Low U.S. Federal Government Contracting Risk -- Ideologically Opposed Agencies", size(small)) subtitle("Omit Set-Asides: [Multiple Bids & Fixed Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(-.2(0.2)0.7)


***Figure A3.4A***

twoway (scatter change alignment if model==11) (rcap ll ul alignment if model==11), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for High U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A3.4A: High U.S. Federal Government Contracting Risk -- Ideologically Aligned Agencies", size(small)) subtitle("Omit Set-Asides: [Single Bid (Closed) & Variable Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(0(0.05)0.15)



***Figure A3.5A***

twoway (scatter change alignment if model==12) (rcap ll ul alignment if model==12), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for High U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A3.5A: High U.S. Federal Government Contracting Risk -- Ideologically Opposed Agencies", size(small)) subtitle("Omit Set-Asides: [Single Bid (Closed) & Variable Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(0(0.05)0.15)




***SI Document, Section A4 - Single Bid [Open] ***

***Figure A4.4A***

twoway (scatter change alignment if model==13) (rcap ll ul alignment if model==13), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for High U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A4.4A: High U.S. Federal Government Contracting Risk -- Ideologically Aligned Agencies", size(small)) subtitle("[Single Bid (Open) & Variable Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(0(0.05)0.15)



***Figure A4.5A***

twoway (scatter change alignment if model==14) (rcap ll ul alignment if model==14), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for High U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A4.5A: High U.S. Federal Government Contracting Risk -- Ideologically Opposed Agencies", size(small)) subtitle("[Single Bid (Open) & Variable Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(0(0.05)0.15)



***SI Document, Section A5 - Sans Covariates***


***Figure A5.2A***

twoway (scatter change alignment if model==15) (rcap ll ul alignment if model==15), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for Low U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A5.2A: Low U.S. Federal Government Contracting Risk -- Ideologically Aligned Agencies", size(small)) subtitle("Omit Covariates: [Multiple Bids & Fixed Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(-.2(0.2)0.7)

***Figure A5.3A***

twoway (scatter change alignment if model==16) (rcap ll ul alignment if model==16), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for Low U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A5.3A: Low U.S. Federal Government Contracting Risk -- Ideologically Opposed Agencies", size(small)) subtitle("Omit Covariates: [Multiple Bids & Fixed Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(-.2(0.2)0.7)


***Figure A5.4A***

twoway (scatter change alignment if model==17) (rcap ll ul alignment if model==17), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for High U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A5.4A: High U.S. Federal Government Contracting Risk -- Ideologically Aligned Agencies", size(small)) subtitle("Omit Covariates: [Single Bid (Closed) & Variable Cost Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(0(0.05)0.15)



***Figure A5.5A***

twoway (scatter change alignment if model==18) (rcap ll ul alignment if model==18), plotregion(m(medium)) xlabel(1 "Non-Exec Low AP" 1.5 "Exec Low AP" 2 "Exec/Non-Exec LAP Difference" 3 "Non-Exec High AP" 3.5 "Exec High AP" 4 "Exec/Non-Exec HAP Difference" 5 "Non-Exec HAP - LAP Difference" 5.5 "Exec HAP - LAP Difference", labsize(vsmall)) yline(0, lwidth(medthick) lpattern(dash)) ytitle("Predicted Probabilities for High U.S. Federal Government Contracting Risk", size(vsmall)) xtitle(Alternative Configurations of Decision Level & Appointee Politicization)  title("FIGURE A5.5A: High U.S. Federal Government Contracting Risk -- Ideologically Opposed Agencies", size(small)) subtitle("Omit Covariates: [Single Bid (Closed) & Variable Structure]", size(small)) plotregion(margin(large)) legend(off) scheme(sj) ylabel(0(0.05)0.15)




log using sellingout.figures3.5.calculations.smcl

***Manuscript Figure 3***


***marginal probability effect × number of multiple bid and fixed cost [or single closed bid & variable cost] procurements***

*** FOR FIGURES 3A & 3B -- CONVERT ESTIMATES 3, 6, 7, & 8 [IDEOLOGICALLY ALIGNED]  PLUS 11, 14, 15 & 16 [IDEOLOGICALLY OPPOSED] IN TERMS OF THE FOLLOWING: (A) PREDICTED NUMBER OF CONTR
*> ACTS AFFECTED AMONG LOW RISK CONTRACTS IN
*. *                          SAMPLE, (B) PREDICTED TOTAL MONETARY VALUE AFFECTED AMONG LOW RISK CONTRACTS IN SAMPLE, & (C) PREDICTED PROPORTION OF MONETARY VALUE AFFECTED AMONG LOW RISK 
*> CONTRACTS IN SAMPLE  
 
*. * FIGURE 2B [IDEOLOGICALLY ALIGNED AGENCIES] -- PLACEMENT OF ESTIMATES:  3(A-C)    6(A-C)          7(A-C)    8(A-C)
*. * FIGURE 3B [IDEOLOGICALLY OPPOSED AGENCIES] -- PLACEMENT OF ESTIMATES: 11(A-C)   14(A-C)         15(A-C)   16(A-C) 

**marginal probability effect × number of multiple bid and fixed cost [or single closed bid & variable cost] procurements

***Figure 3A

***Estimate 3 Conversion***

probit m11 c.agency_packing##execlevel##pol_align  c.agency_packing##execlevel##pol_opposed  perc_prof  selin1_abszero  selin2_abszero unified lnannualrevenue_adj house_app house_ways house_majority  close_congelect_dist     dod dc_area goods_services lnvendorsum_adj lndollarsobligated_adj  pres_donor_pac lnpres_donor_pac_amount_adj   i.agency yearfe2 yearfe3 yearfe4 yearfe5 yearfe6 yearfe7 yearfe8 yearfe9 yearfe10 yearfe11 yearfe12 yearfe13 yearfe14 yearfe15 yearfe16   i.psc_id, vce(cluster agency)

tab m11 if pol_align==1 & e(sample)

***3A: -.1302867 * 66086
display -.1302867 * 66086

***-8610.1269

***3B: 
sum dollarsobligated_adj if pol_align==1 & m11==1 & e(sample)
dis r(sum)
***Total Value of m11 aligned contracts = 413900000000, or $413,900,000,000, mean is 6,307,187

***-8610.1269 * 6,307,187
display 8610.1269 * 6307187
***-5.431e+10

***3C 
*** -5.431e+10 / 413900000000
display -5.431e+10 / 413900000000

** -.13121527 or -13.1%


***Estimate 6 Conversion***
tab m11 if pol_align==1 & e(sample)

***6A: -.1109583 * 66086
display -.1109583 * 66086

***-7332.7902

***6B:
sum dollarsobligated_adj if pol_align==1 & m11==1 & e(sample)
dis r(sum)
***Total Value of m11 aligned contracts = 413900000000, or $413,900,000,000, mean is 6,307,187


***-7332.7902 * 6,307,187
display -7332.7902*6307187
*-4.625e+10

***6C:
*-4.625e+10 / 413900000000
dis -4.625e+10 / 413900000000
*-.11174197 or -11.2%

***Estimate 7 Conversion***
tab m11 if execlevel==0 & pol_align==1 & e(sample) & m11==1
*48578

***7A: -0.0329541 * 48578
*-1600.8443

***7B:
sum dollarsobligated_adj if execlevel==0 & pol_align==1 & e(sample) & m11==1
dis r(sum)
***Total Value of non-execlevel aligned contracts = 3.159e+11, mean is 6,543,984

***-1600.8443 * 6543984
display -1600.8443 * 6543984
*-1.048e+10

***7C
*-13770000000/1145000000000
dis -1.048e+10/3.159e+11
* -.03317506 or -3.3%


***Estimate 8 Conversion***
tab m11 if execlevel==1 & pol_align==1 & e(sample)
*17508

***8A: -0.0136248 * 17508
dis -0.0136248 * 17508
*-238.543

***8B:
sum dollarsobligated_adj if execlevel==1 & pol_align==1 & e(sample) & m11==1
dis r(sum)
***Total Value of execlevel aligned = 9.792e+10, mean is 5647756

***-238.543 * 5647756
dis -238.543 * 5647756
*-1.347e+09

***8C:
*-1109000000 / 324000000000
dis -1.347e+09 / 9.792e+10
* -.01375613 or -1.4%



***Manuscript Figure 3B*** Opposed
*FIGURE 3B [IDEOLOGICALLY OPPOSED AGENCIES] -- PLACEMENT OF ESTIMATES: 11(A-C)   14(A-C)         15(A-C)   16(A-C) 

***Estimate 11 Conversion***
tab m11 if pol_opposed==1 & e(sample)
*219311

***11A: -0.0568164*219311
dis -0.0568164*219311
*-12460.462

***11B:
sum dollarsobligated_adj if pol_opposed & e(sample) & m11==1
dis r(sum)
***Total Value of opposed = 8.590e+11, mean is 3947618
***-12460.462*3947618
dis -12460.462*3947618
*-4.919e+10

***11C:
*-4.919e+10 / 8.590e+11
dis -4.919e+10 / 8.590e+11
*-.05726426 or -5.7%


***Estimate 14 Conversion***
tab m11 if pol_opposed==1 & e(sample)
*219311

***14A: -0.078927*219311
dis -0.078927*219311
* -17309.559

***14B:
sum dollarsobligated_adj if pol_opposed & e(sample) & m11==1
dis r(sum)
***Total Value of opposed = 8.590e+11, mean is 3947618
*-17309.559*5892701
dis -17309.559*3947618
*-6.833e+10

***14C:
*-6.833e+10 / 8.590e+11
dis -6.833e+10 / 8.590e+11
*-.07954598 or -8%



***Estimate 15 Conversion***
tab m11 if execlevel==0 & pol_opposed==1 & e(sample)
*184408

***15A: .0110203 * 184408
dis .0110203 * 184408
*2032.2315

***15B
sum dollarsobligated_adj if execlevel==0 & pol_opposed==1 & e(sample) & m11==1
dis r(sum)
*Total Value of opposed nonexeclevel: 7.392e+11, mean is 4043422

*2032.2315 * 6486992
dis 2032.2315 * 4043422
*8.217e+09

***15C
*8.217e+09 / 7.392e+11
dis 8.217e+09 / 7.392e+11
*.01111607 or 1.1%

***Estimate 16 Conversion***
tab m11 if execlevel==1 & pol_opposed==1 & e(sample)
*34903

***16A: 
dis -.0110902*34903
*-387.08125

***16B
sum dollarsobligated_adj if execlevel==1 & pol_opposed==1 & e(sample) & m11==1
dis r(sum)
*Total Value of opposed execlevel: 1.199e+11, mean is 3444347 

*-387.08125*3444347 
dis -387.08125*3444347 
*-1.333e+09

***16C
*-1.333e+09 / 1.199e+11
dis -1.333e+09 / 1.199e+11
*-.0111176 or -1.1%




*******************************

***Figures 4B and 5B - High Risk Contracts***
* FIGURE 4B [IDEOLOGICALLY ALIGNED AGENCIES] -- PLACEMENT OF ESTIMATES:  3(A-C)    6(A-C)          7(A-C)    8(A-C)
* FIGURE 5B [IDEOLOGICALLY OPPOSED AGENCIES] -- PLACEMENT OF ESTIMATES: 11(A-C)   14(A-C)         15(A-C)   16(A-C) 


probit m00closed c.agency_packing##execlevel##pol_align  c.agency_packing##execlevel##pol_opposed  perc_prof  selin1_abszero  selin2_abszero unified lnannualrevenue_adj house_app house_ways house_majority  close_congelect_dist   dod dc_area goods_services lnvendorsum_adj lndollarsobligated_adj   pres_donor_pac lnpres_donor_pac_amount_adj i.agency yearfe2 yearfe3 yearfe4 yearfe5 yearfe6 yearfe7 yearfe8 yearfe9 yearfe10 yearfe11 yearfe12 yearfe13 yearfe14 yearfe15 yearfe16  i.psc_id , vce(cluster agency)


***Estimate 3(h) conversion***
tab m00closed if pol_align==1 & e(sample)
*12429

***3A:
*.053718 * 12429
dis .053718 * 12429
*667.66102

***3B***
sum dollarsobligated_adj if pol_align==1 & e(sample) & m00closed==1
dis r(sum)
*Total high risk contract value: 2.052e+11; mean is 1.65e+07
dis 667.66102*1.65e+07
*1.102e+10

***3C***
*1.102e+10 / 2.052e+11
dis 1.102e+10 / 2.052e+11
*.0537037 or 5.4%


***Estimate 6(h) conversion***
tab m00closed if pol_align==1 & e(sample)
*12429

***6(h) conversion***
tab m00closed if pol_align==1 & e(sample)
*12429


***6A:
*.0531645*12492
dis .0531645*12492
*664.13093

***6B***
sum dollarsobligated_adj if pol_align==1 & e(sample) & m00closed==1
dis r(sum)
*Total high risk contract value: 2.052e+11; mean is 1.65e+07
dis 664.13093*1.65e+07
*1.096e+10

***6C***
*1.096e+10/2.052e+11
dis 1.096e+10/2.052e+11
*.05341131 or 5.3%


***7(h) conversion***
tab m00closed if pol_align==1 & e(sample) & execlevel==0
*126,947

*.0016999*126947
dis .0016999*126947
*215.79721

***7B***
sum dollarsobligated_adj if pol_align==1 & execlevel==0 & e(sample) & m00closed==1
dis r(sum)
*Total value: 1.684e+11, mean: 2.93e+07 

dis 215.79721*2.93e+07
*6.323e+09

***7C***
*6.323e+09/1.684e+11
dis 6.323e+09/1.684e+11
*.03754751 or 3.8%


***8(h) Conversion***
tab m00closed if pol_align==1 & e(sample) & execlevel==1
*6,686

***8A***
*.0011463 * 6686
dis .0011463 * 6686
*7.6641618

***8B***
sum dollarsobligated_adj if pol_align==1 & execlevel==1 & e(sample) & m00closed==1
dis r(sum)
*Total value: 3.678e+10, mean: 5501681

*7.6641618 * 5501681
dis 7.6641618 * 5501681 
*42165773

***8C***
*42165773 / 3.678e+10
dis 42165773 / 3.678e+10
*.00114643 or 0.1%



***High Risk - Ideologically Opposed Agencies***
* FIGURE 5B [IDEOLOGICALLY OPPOSED AGENCIES] -- PLACEMENT OF ESTIMATES: 11(A-C)   14(A-C)         15(A-C)   16(A-C) 

***11(h) Conversion***
tab m00closed if pol_opposed==1 & e(sample)
*15,243

***11A***
dis .0545728*15243
*831.85319

***11B***
sum dollarsobligated_adj if pol_opposed==1 & e(sample) & m00closed==1
dis r(sum)
*Total Value: 4.640e+11, mean: 3.04e+07

*831.85319*1.97e+07
dis 831.85319*3.04e+07
*2.529e+10

***11C***
*1.639e+10/5.610e+11
dis 2.529e+10/4.640e+11
*.05450431 or 5.5%


***14(h) Conversion***

tab m00closed if pol_opposed==1 & e(sample)
*15,243

***14A***
dis .0565626*15243
*862.18371

***14B***
sum dollarsobligated_adj if pol_opposed==1 & e(sample) & m00closed==1
dis r(sum)
*Total Value: 4.640e+11, mean: 3.04e+07

*862.18371*3.04e+07
dis 862.18371*3.04e+07
*2.621e+10

***14C***
*2.621e+10/4.640e+11
dis 2.621e+10/4.640e+11
*.05648707 or 5.6%

***15(h) Conversion***
tab m00closed if pol_opposed==1 & e(sample) & execlevel==0
*7477

***15A***
*-.0033201*7477
dis -.0033201*7477
*-24.824388

***15B***
sum dollarsobligated_adj if pol_opposed==1 & e(sample) & m00closed==1 & execlevel==0
dis r(sum)

*Total Value: 4.247e+11, mean: 5.68e+07

dis -24.824388*5.68e+07
*-1.410e+09

***15C***
*-1.410e+09/3.932e+10
dis -1.410e+09/3.932e+10
*-.03585961 or -3.6%

***16(h) Conversion***
tab m00closed if pol_opposed==1 & e(sample) & execlevel==1
*7766

***16A***
*-.0013303*7766
dis -.0013303*7766
*-10.33111

***16B***
sum dollarsobligated_adj if pol_opposed==1 & e(sample) & m00closed==1 & execlevel==1
dis r(sum)
*Total value: 3.932e+10, mean: 5063327

dis -10.33111*5063327
*-52309788

***16C***
*-52309788/3.932e+10
dis -52309788/3.932e+10
*-.00133036 or 0.1%

log close

use "C:\Users\matt_zarit\Dropbox\Executive Particularism (Matt Zarit)\Contract Duration\May 2020\Graphics Files\sellingout.figure35data.6032021.dta saved"

***Figure 2B***
twoway bar predcount level if figure_num==3, yaxis(2) ytitle("Predicted Change in Number of Contracts", axis(2) size(small))  || bar predvalue level if figure_num==3, yaxis(1) ytitle("Predicted Change in Constant Dollar Value", axis(1) size(small)) title("FIGURE 2B: Predicted Change in Both Volume and Value of Low Risk U.S. Government Contracts", size(small)) xlabel(1.5 "Exec/Non-Exec LAP Difference" 4.5 "Exec/Non-Exec HAP Difference" 7.5 "Non-Exec HAP - LAP Difference" 10.5 "Exec HAP - LAP Difference", labsize(vsmall) noticks) subtitle("[Ideologically Aligned Agencies: By Level of Appointee Politicization and Decision Level]") scheme(sj) plotregion(margin(large))

***Figure 3B***
twoway bar predcount level if figure_num==4, yaxis(2) ytitle("Predicted Change in Number of Contracts", axis(2) size(small))  || bar predvalue level if figure_num==4, yaxis(1) ytitle("Predicted Change in Constant Dollar Value", axis(1) size(small)) title("FIGURE 3B: Predicted Change in Both Volume and Value of Low Risk U.S. Government Contracts", size(small)) xlabel(1.5 "Exec/Non-Exec LAP Difference" 4.5 "Exec/Non-Exec HAP Difference" 7.5 "Non-Exec HAP - LAP Difference" 10.5 "Exec HAP - LAP Difference", labsize(vsmall) noticks) subtitle("[Ideologically Opposed Agencies: By Level of Appointee Politicization and Decision Level]") scheme(sj) plotregion(margin(large))


***Figure 5A***
twoway bar predcount level if figure_num==5, yaxis(2) ytitle("Predicted Change in Number of Contracts", axis(2) size(small))  || bar predvalue level if figure_num==5, yaxis(1) ytitle("Predicted Change in Constant Dollar Value", axis(1) size(small)) title("FIGURE 4B: Predicted Change in Both Volume and Value of High Risk U.S. Government Contracts", size(small)) xlabel(1.5 "Exec/Non-Exec LAP Difference" 4.5 "Exec/Non-Exec HAP Difference" 7.5 "Non-Exec HAP - LAP Difference" 10.5 "Exec HAP - LAP Difference", labsize(vsmall) noticks) subtitle("[Ideologically Aligned Agencies: By Level of Appointee Politicization and Decision Level]") scheme(sj) plotregion(margin(large))

***Figure 5B***
twoway bar predcount level if figure_num==6, yaxis(2) ytitle("Predicted Change in Number of Contracts", axis(2) size(small))  || bar predvalue level if figure_num==6, yaxis(1) ytitle("Predicted Change in Constant Dollar Value", axis(1) size(small)) title("FIGURE 5B: Predicted Change in Both Volume and Value of High Risk U.S. Government Contracts", size(small)) xlabel(1.5 "Exec/Non-Exec LAP Difference" 4.5 "Exec/Non-Exec HAP Difference" 7.5 "Non-Exec HAP - LAP Difference" 10.5 "Exec HAP - LAP Difference", labsize(vsmall) noticks) subtitle("[Ideologically Opposed Agencies: By Level of Appointee Politicization and Decision Level]") scheme(sj) plotregion(margin(large))
